package com.third.mapper;

import com.third.entity.InboundOrder;
import com.third.entity.Quality;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

/**
 * @author 唐燈
 * @version 1.1
 * @date 2023/10/30 12:04
 */
@Mapper
public interface QualityMap {
    @Insert("insert into quality_test(test_id,brand_id,test_date,test_pass,test_number) " +
            "values(#{testId},#{brandId},#{testDate},#{testPass},#{testNumber})")
    void insert(Quality quality);

    @Update("update quality_test set test_id=#{testId},brand_id=#{brandId},test_date=#{testDate},tester=#{tester},test_pass=#{testPass},test_number=#{testNumber} where test_id=#{testId} ")
    void update(Quality quality);

    @Delete("delete from quality_test where test_id=#{testId}")
    void delete(Integer testId);
}
